SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Tests](
	[TestID] [INT] IDENTITY(1,1) NOT NULL,
	[ProductID] [INT] NOT NULL,
	[TestCode] [NVARCHAR](15) NOT NULL,
	[TestedDate] [DATETIME] NOT NULL,
	[Enterprise] [NVARCHAR](50) NULL,
	[TestMachine] [NVARCHAR](50) NULL,
	[TestWeight] [DECIMAL](18, 2) NOT NULL,
	[LostWeight] [DECIMAL](18, 2) NOT NULL,
	[TestVolume] [DECIMAL](18, 2) NOT NULL,
	[TestResult] [NVARCHAR](15) NOT NULL,
	[Description] [NVARCHAR](200) NOT NULL,
	[CreatedBy] [INT] NOT NULL,
	[CreatedDate] [DATETIME] NOT NULL,
	[UpdatedBy] [INT] NOT NULL,
	[UpdatedDate] [DATETIME] NOT NULL,
	[IsDeleted] [BIT] NOT NULL,
	[IsActived] [BIT] NOT NULL,
	[Tstamp] [TIMESTAMP] NOT NULL,
 CONSTRAINT [PK_Tests] PRIMARY KEY CLUSTERED 
(
	[TestID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


